{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Farm Calculator","Graph - costs","Graph - store sheep vaccination","Graph breeding sheep vaccinatio"],"not_rendered":{"charts":6,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Graph - costs","index":1,"reason":"not_a_worksheet"},{"sheet":"Graph - store sheep vaccination","index":2,"reason":"not_a_worksheet"},{"sheet":"Graph breeding sheep vaccinatio","index":3,"reason":"not_a_worksheet"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Farm Calculator","index":0,"n_rows":86,"n_cols":7,"rows_kept":86,"cut":false,"hidden":false,"merged":[[21,1,21,5],[1,1,1,3],[56,1,56,4],[58,1,58,4],[18,1,18,4],[19,1,19,4],[57,1,57,4]]}
[]
[null,"How much will farmers spend or save by vaccinating their sheep against BTV-3?"]
[]
[]
[null,"Step 1. Input your data in the blue cells"]
[]
[null,"How many store sheep/lambs do you have?",null,"  Use the number of lambs you expect to wean"]
[]
[null,"How many breeding females do you have?",null,"  Use the number of ewes you expect to tup"]
[]
[null,"What is the expected store sheep value?",138,"  Default value £138 is a suggested average figure for 2024"]
[]
[null,"What is the expected breeding female value?",130,"  Default value £130 is a suggested average figure for 2024"]
[]
[null,"What is the vaccination cost per sheep?",5,"  Please talk to your vet to get an up-to-date figure"]
[]
[null,"Step 2. Review your results",null,""]
[]
[null,"The tables below show the impact of BTV-3 infection in different scenarios, based on the numbers you provide in step 1. The scenarios represent mild infection (A) through to severe infection (D). AHDB has developed each scenario based on actual data from the UK and mainland Europe. "]
[null,"The calculator doesn't allow you to mix the scenarios - so the results won't be valid if you take productivity costs from Scenario A and add mortality costs from Scenario B etc. You need to follow the same scenario throughout."]
[]
[null,"Productivity costs - we estimate that infected sheep will lose around 10% of their value due to slower growth and the additional treatment costs."]
[0.05,"Scenario","Store sheep","Breeding sheep","Total"]
[0.1,"A) If 5% of your sheep are infected",{"$f":"$C$7*(A23*$B$71)*$C$11","v":0},{"$f":"$C$9*A23*($C$13*$B$71)","v":0},{"$f":"SUM(C24:D24)","v":0}]
[0.25,"B) If 10% of your sheep are infected",{"$f":"$C$7*(A24*$B$71)*$C$11","v":0},{"$f":"$C$9*A24*($C$13*$B$71)","v":0},{"$f":"SUM(C25:D25)","v":0}]
[0.5,"C) If 25% of your sheep are infected",{"$f":"$C$7*(A25*$B$71)*$C$11","v":0},{"$f":"$C$9*A25*($C$13*$B$71)","v":0},0]
[null,"D) If 50% of your sheep are infected",{"$f":"$C$7*(A26*$B$71)*$C$11","v":0},{"$f":"$C$9*A26*($C$13*$B$71)","v":0},0]
[]
[null,"Mortality costs - the lost value from sheep that die"]
[0.1,"Scenario","Store sheep","Breeding sheep","Total"]
[0.25,"A) If 10% of infected animals die",{"$f":"($C$7*A23*A30)*$C$11","v":0},{"$f":"($C$9*A23*A30)*$C$13","v":0},{"$f":"SUM(C31:D31)","v":0}]
[0.4,"B) If 25% of infected animals die",{"$f":"($C$7*A24*A31)*$C$11","v":0},{"$f":"($C$9*A24*A31)*$C$13","v":0},{"$f":"SUM(C32:D32)","v":0}]
[0.6,"C) If 40% of infected animals die",{"$f":"($C$7*A25*A32)*$C$11","v":0},{"$f":"($C$9*A25*A32)*$C$13","v":0},0]
[null,"D) If 60% of infected animals die",{"$f":"($C$7*A26*A33)*$C$11","v":0},{"$f":"($C$9*A26*A33)*$C$13","v":0},0]
[]
[null,"Fertility costs - infected sheep can have reduced fertility"]
[0.05,"Scenario","Store sheep","Breeding sheep","Total"]
[0.1,"A) 5% reduction in lambs from infected sheep","n/a",{"$f":"($C$9*A37*A23)*$C$11","v":0},{"$f":"D38","v":0}]
[0.15,"B) 10% reduction in lambs from infected sheep","n/a",{"$f":"($C$9*A38*A24)*$C$11","v":0},{"$f":"D39","v":0}]
[0.2,"C) 15% reduction in lambs from infected sheep","n/a",{"$f":"($C$9*A39*A25)*$C$11","v":0},0]
[null,"D) 20% reduction in lambs from infected sheep","n/a",{"$f":"($C$9*A40*A26)*$C$11","v":0},0]
[]
[null,"Step 3. Understand the cost of vaccination"]
[]
[null,null,"Store sheep","Breeding sheep","Total"]
[null,"How much will it cost to vaccinate your sheep?",{"$f":"C7*C15","v":0},{"$f":"C9*C15","v":0},{"$f":"D46+C46","v":0}]
[]
[null,"How much will vaccinating your sheep save you? - we assume a 50% reduction in infections and 75% reduction in mortality."]
[]
[null,"Scenario","Store sheep","Breeding sheep","Total"]
[null,"Scenario A - Mild infection",{"$f":"(C24*$B$69)+(C31*$F$69)","v":0},{"$f":"(D24*$B$69)+(D31*$F$69)+(D38*$B$69)","v":0},{"$f":"D51+C51","v":0}]
[null,"Scenario B - Mild to moderate infection",{"$f":"(C25*$B$69)+(C32*$F$69)","v":0},{"$f":"(D25*$B$69)+(D32*$F$69)+(D39*$B$69)","v":0},{"$f":"D52+C52","v":0}]
[null,"Scenario C - Moderate to severe infection",{"$f":"(C26*$B$69)+(C33*$F$69)","v":0},{"$f":"(D26*$B$69)+(D33*$F$69)+(D40*$B$69)","v":0},0]
[null,"Scenario D - Severe infection",{"$f":"(C27*$B$69)+(C34*$F$69)","v":0},{"$f":"(D27*$B$69)+(D34*$F$69)+(D41*$B$69)","v":0},0]
[]
[]
[null,"1. Savings are calculated by accounting for the number of sheep you have identified, the cost of the vaccine and the effect of productivity, mortality and reduced fertility. It does not include costs associated with gathering the flock for vaccination, labour and consumables or costs for the disposal of dead stock."]
[null,"2. The calculator does not assess the impact on rams, which should be the highest priority sheep for vacination on farm due to their high value and the potential impact of BTV-3 on the ram's fertllity. "]
[null,"3. Results from this calculator are based on a series of assumptions and should be treated as a tool to aid decision-making on-farm. Actual impacts will vary depending on the specific outbreak of BTV-3. Always seek advice of your vet to fully assess the risks and the cost-benefits as part of your herd health planning. Please note that vaccination will reduce clinical signs and mortality, but it will not eliminate them altogether. "]
[null,"For more information and advice on Bluetongue please visit the AHDB website: "]
[null,"Bluetongue virus latest news | AHDB"]
[]
[]
[]
[]
[]
[]
["hidden data"]
["vaccination impact on infection",0.5,"set value which can not be changed",null,null,{"$f":"B70+B69","v":1.25},"vaccination impact on ingection + mortality"]
["vaccination impact on mortality",0.75,"set value which can not be changed"]
["value drop for infected sheep",0.1,"set value which can not be changed"]
[]
[]
[null,"Store sheep vaccination cost","Store sheep savings","Breeding sheep vaccination cost","Breeding sheep savings"]
[null,{"$f":"C46","v":0},{"$f":"C51","v":0},{"$f":"D46","v":0},{"$f":"D51","v":0}]
[null,{"$f":"C46","v":0},{"$f":"C52","v":0},{"$f":"D46","v":0},{"$f":"D52","v":0}]
[null,{"$f":"C46","v":0},{"$f":"C53","v":0},{"$f":"D46","v":0},0]
[null,{"$f":"C46","v":0},{"$f":"C54","v":0},{"$f":"D46","v":0},0]
[]
[]
[]
[null,"Productivity costs","Mortality costs","Fertility costs"]
["Scenario A - mild",{"$f":"E24","v":0},{"$f":"E31","v":0},{"$f":"D38","v":0}]
["Scenario B - mild to moderate",{"$f":"E25","v":0},{"$f":"E32","v":0},{"$f":"D39","v":0}]
["Scenario C - moderate to severe",{"$f":"E26","v":0},{"$f":"E33","v":0},{"$f":"D40","v":0}]
["Scenario D - severe",{"$f":"E27","v":0},{"$f":"E34","v":0},{"$f":"D41","v":0}]